package com.lzw.DailyAudit.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author lzw
 * @since 2025-09-11
 */
@Mapper
public interface DailyXsjl2303Mapper {

	@DS("dwd")
    @Select("SELECT DISTINCT dwd.store AS store FROM (select * from dwd.dwd_ord_ordinfo_r where upper(country)='EU'and ordertype>=0 and state=0) dwd")
    List<String> getStores();

	@DS("dwd")
    @Select("SELECT DISTINCT UPPER(dwd.orderid) AS orderid FROM (select * from dwd.dwd_ord_ordinfo_r where upper(country)='EU'and ordertype>=0 and state=0) dwd WHERE dwd.store='oeu' AND dwd.orderid NOT IN ('OEU20250526-1')")
    List<String> getOeuIds();


    List<String> selectSkuList(String startDate, String endDate);

}
